CHECK constraint

An ANSI SQL-92 concept that allows for business rules that span an entire table or multiple other tables to be created. An example of this would be to create a Customer table and an Order table. The Order table could have a CHECK constraint that would prevent orders for a customer from exceeding a credit limit defined for the customer in the Customer table.